Ques 76. Why does the following command give a compilation error?
DROP TABLE &TABLE_NAME; Variable names should start with an alphabet. Here the table name starts with an '&' symbol.
Is it helpful?
Add CommentView Comments
Ques 77. Which system tables contain information on privileges granted and privileges obtained?
USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD
Is it helpful?
Add CommentView Comments
Ques 78. Which system table contains information on constraints on all the tables created?
USER_CONSTRAINTS.
Is it helpful?
Add CommentView Comments
Ques 79. What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.
DELETE is a DML command and can be rolled back.
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.
Is it helpful?
Add CommentView Comments
Ques 80. State true or false. !=, <>, ^= all denote the same operation?